Add a Lookup Table to a Query

Optionally, you can specify that a Query access a specific Lookup table, as it may contain data the Query needs.

Note: Before you can add a Lookup table, the Query must first have results. See Refresh a Query for more information on this process.

To add a Lookup table to a Query:

  1. Select Analytics from the top navigation bar, then select Settings > Queries from the side navigation menu. The Analytics Queries screen is displayed.

  2. Optionally, search for and select the desired Query (see Search for a Query Search for a Query more information on the available search options). The Query Details screen is displayed, with the Definition tab selected.

  3. Select the KPIs and Lookups tab.

  4. Within the Lookups section, click Edit. The Edit Bigdata Query pop-up window is displayed.

  1. Click Add Lookup.

  2. From the Lookup drop-down menu, select the desired Lookup table.

  3. From the Column drop-down menu, select the column on which you want to look up records.

  4. Optionally, repeat the above steps as needed to add other Lookup tables and columns.

  5. Optionally, to remove a Lookup table from this Query, click the Remove icon next to it.

  6. Click Save.